Method for partially publishing edits to a document

ABSTRACT

A method for partially publishing edits to a document is described. A first document including a first cell and a second cell is displayed on first user account on a first computing device and on a second user account. A second document including a linked version of the first cell and a linked version of the second cell is displayed. An edit of the first cell is received from the first user account and an edit of the second cell is received. In response to receiving an indication from the first user account that the edit of the first cell is to be published, the edit of the first cell is made to the linked version of the first cell, while the linked version of the second cell is unchanged so that the content of the linked version of the second cell no longer matches that of the second cell.

CROSS-REFERENCE TO RELATED APPLICATIONS

This application claims the priority benefit of U.S. Provisional PatentApplication No. 62/893,430, filed on Aug. 29, 2019, which isincorporated herein by reference in its entirety.

TECHNICAL FIELD

The disclosure relates generally to cloud-based document collaborationand, more particularly, to methods for partially publishing changes to adocument.

BACKGROUND

Current cloud-based document collaboration platforms usually default toreal-time, unrestricted editing by all collaborators. That is,collaborators see edits made by others in real time or nearly real time,and sharing edits with people outside of the collaboration team is anall-or-nothing proposition. There are many situations however, where onemay not necessarily be ready to share all of one's changes with peopleoutside of the team.

SUMMARY

In an embodiment, a method for partially publishing edits to a documentincludes: displaying, on a first user account on a first computingdevice and on a second user account, a first document comprising a firstcell and a second cell; displaying a second document comprising a linkedversion of the first cell and a linked version of the second cell,wherein the content of the linked version of the first cell matches thatof the first cell and the content of the linked version of the secondcell matches that of the second cell; receiving, from the first useraccount, an edit of the first cell; receiving, from the second useraccount, an edit of the second cell; receiving, from the first useraccount, an indication that the edit of the first cell is to bepublished; making the edit of the first cell to the linked version ofthe first cell; and leaving the linked version of the second cellunchanged so that the content of the linked version of the second cellno longer matches that of the second cell.

According to an embodiment, a method for partially publishing edits to adocument includes displaying, on a first user account on a firstcomputing device and on a second user account, a first cell and a secondcell in a table of a first document; displaying a linked version of thefirst cell and a linked version of the second cell in a second document;receiving, from the first user account, an edit of the first cell;receiving an edit of the second cell; receiving, from the first useraccount, an indication that the edit of the first cell is to bepublished; making the edit of the first cell to the linked version ofthe first cell; and when the first and second cell are referenced by acommon formula in the table, making the edit of the second cell to thelinked version of the second cell.

In an embodiment, a method for partially publishing edits to a documentincludes displaying, on a first user account on a first computing deviceand on a second user account, a first document comprising a first celland a second cell, wherein the first user account is being used by afirst user and the second user account is being used by a second user;displaying a second document comprising a linked version of the firstcell and a linked version of the second cell, wherein the content of thelinked version of the first cell matches that of the first cell and thecontent of the linked version of the second cell matches that of thesecond cell; receiving, from the first user account, an edit to thefirst cell; receiving, from the second user account, an edit to thesecond cell; presenting, on the first user account, an on-screen controlthat includes a first option to publish only changes made by the firstuser and a second option to publish changes made by both the first userand the second user; providing an operation defined by: when the firstuser selects the first option, making the edit of the first cell to thelinked version of the first cell, and leaving the linked version of thesecond cell unchanged so that the content of the linked version of thesecond cell no longer matches that of the second cell; when the firstuser selects the second option, making the edit of the first cell to thelinked version of the first cell, and making the edit of the second cellto the linked version of the second cell.

DRAWINGS

While the appended claims set forth the features of the presenttechniques with particularity, these techniques may be best understoodfrom the following detailed description taken in conjunction with theaccompanying drawings of which:

FIG. 1 is a block diagram illustrating an example networking environmentin which various embodiments of the disclosure may be employed.

FIG. 2 is a block diagram of a computing device, according to anembodiment.

FIGS. 3A-3G illustrate a graphical user interface in which multipleusers collaborate on a document and are able to limit publication ofedits to a selected subset of edits, according to an embodiment.

FIGS. 4A-4E illustrate a graphical user interface of a consumer of someof the data generated in the document of FIGS. 3A-3G, according to anembodiment.

DETAILED DESCRIPTION

According to various embodiments, a method for partially publishingedits to a document allows users collaborating on a shared document, inwhich the document includes data that is being “consumed” by (is linkedto) one or more other documents, to select which edits are to bepublished. Edits that are published are reflected in the linked versionsof the data, while edits that are unpublished remain “private” to thecollaborators. In the context of table cells (e.g., cells of aspreadsheet), the method makes intelligent determinations whether cellsthat are designated to be published should cause other cells (e.g.,cells referenced by a common formula) to be published as well, even ifsuch other cells have not been selected by any of the collaborators tobe published.

Various embodiments of the disclosure are implemented in a computernetworking environment. Turning to FIG. 1, an example of such anenvironment is shown. A first computing device 100 (e.g., a hardwareserver device (also referred to as the “server” or the “server device”)or a cluster of hardware server devices) is communicatively linked to anetwork 102. Possible implementations of the network 102 include alocal-area network, a wide-area network, a private network, a publicnetwork (e.g., the Internet), or any combination of these. The network102 may include both wired and wireless components. Also communicativelylinked to the network 102 are a second computing device 104 (alsoreferred to as a “first client device” or, when there is no specificmention of the first computing device 100, the “first computingdevice”), a third computing device 106 (also referred to as a “secondclient device” or, when there is no specific mention of the firstcomputing device 100, the “second computing device”), a fourth computingdevice 108 (also referred to as a “third client device” or, when thereis no specific mention of the first computing device 100, the “thirdcomputing device”), and a fifth computing device 110 (e.g., a server ora cluster of servers, also referred to herein as “SaaS server”). For thesake of the various examples described herein, a first user 104 b isassumed to operate the first client device 104, a second user 106 b isassumed to operate the second client device 106, and a third user 108 bis assumed to operate the third client device 108. It should be notedthat the networking environment may include any number of computingdevices (e.g., hundreds of client devices) and the number depicted inFIG. 1 is meant only to be representative.

It is to be understood that various embodiments may be carried out onthe server device 100, the first client device 104, the second clientdevice 106, the third client device 108, or other computing devices notdepicted, with one or more of the first client device 104, the secondclient device 106, and the third client device 108 accessing the serverdevice 100 via client programs (labeled 104 a, 106 a, and 108 arespectively), such as thin, web-based clients. In an embodiment, theserver device 100 executes productivity software 100 a (e.g., a documentediting application, a spreadsheet application, etc.) and the SaaSserver 110 executes software-as-a-service (“SaaS”) platform software 110a. The first computing device 100 and the SaaS server 110 arecommunicatively linked to a media storage device 112 (e.g., a memory ora redundant array of independent disks). Although FIG. 1 depicts themedia storage device 112 as a single device, in fact, the media storagedevice 112 may be implemented as a single computing device or asmultiple computing devices working together, and may represent a cloudstorage service including multiple storage devices.

In another embodiment, the productivity software 100 a and the SaaSplatform software 110 a execute on the same computing device (e.g., theserver device 100 or the SaaS server 110). For example, the productivitysoftware 100 a could reside on one partition of the server device 100while the SaaS platform software 110 a could reside on another partitionof the server device 100. In other embodiments, portions of theproductivity software 100 a execute on both the server device 100 andone or more of the first, second, and third client devices 104, 106, and108 and/or portions of the SaaS platform software 110 a may be executedon both the server device 100 and the SaaS server 110. With such networkconfigurations, the first client device 104, the second client device106, and the third client device 108 are configured to access thecomputing device or devices on which the productivity software 100 aresides.

Stored on the media storage device 112 is a database 114, which ismaintained by the SaaS platform software 110 a, but whose operations arecontrolled by the productivity software 100 a, which issues instructionsto read from, write to, and modify the contents of the database 114 viathe SaaS platform software 110 a.

In one implementation, one or more of the computing devices of FIG. 1(including the media storage device 112) have the general architectureshown in FIG. 2. The computing device of FIG. 2 includes processorhardware 202 (e.g., a microprocessor, controller, orapplication-specific integrated circuit) (hereinafter “processor 202”),a primary memory 204 (e.g., volatile memory, random-access memory), asecondary memory 206 (e.g., non-volatile memory), user input devices 208(e.g., a keyboard, mouse, or touchscreen), a display device 210 (e.g.,an organic, light-emitting diode display), and a network interface 212(which may be wired or wireless). Each of the elements of FIG. 2 iscommunicatively linked to one or more other elements via one or moredata pathways 213. Possible implementations of the data pathways 213include wires, conductive pathways on a microchip, and wirelessconnections. In an embodiment, the processor 202 is one of multipleprocessors in the computing device, each of which is capable ofexecuting a separate thread. In an embodiment, the processor 202communicates with other processors external to the computing device inorder to initiate the execution of different threads on those otherprocessors.

Referring still to FIG. 2, the memories 204 and 206 store instructionsexecutable by the processor 202 and data. The term “local memory” asused herein refers to one or both the memories 204 and 206 (i.e., memoryaccessible by the processor 202 within the computing device). In someembodiments, the secondary memory 206 is implemented as, or supplementedby an external memory 206A. The media storage device 110 is a possibleimplementation of the external memory 206A. The processor 202 executesthe instructions and uses the data to carry out various proceduresincluding, in some embodiments, the methods described herein, includingdisplaying a graphical user interface 219. The graphical user interface219 is, according to one embodiment, software that the processor 202executes to display a report on the display device 210, and whichpermits a user to make inputs into the report via the user input devices208.

This disclosure may sometimes refer to one or more of the client program104 a, the client program 106 a, the client program 108 a, theproductivity software 100 a, the server device 100, the first clientdevice 104, the second client device 106, or the third client device 108as taking one or more actions. It is to be understood that such actionsmay involve one or more of the client program 104 a, the client program106 a, the client program 108 a, and the productivity software 100 ataking such actions as: (a) the client program transmitting hypertexttransport protocol commands such as “Get” and “Post” in order totransmit to or receive information from the productivity software 100 a(e.g., via a web server), and (b) the client program running a script(e.g., JavaScript) to send information to and retrieve information fromthe productivity software 100 a. The productivity software 100 a mayultimately obtain information (e.g., web pages or data to feed intoplugins used by the client programs) from the database 114 or the SaaSplatform software 110 a. It is to be understood, however, that when acomputing device (or software executing thereon) carries out an action,it is the processor hardware 202 (the main processor and/or one or moresecondary processors, such as a graphics processing unit, hardwarecodec, input-output controller, etc.) that carries out the action at thehardware level.

The disclosure will also refer to actions taking place via a userinterface. There are various ways in which this takes place. In anembodiment, a client program on a client computing device (such as oneof the computing devices 104, 106, and 108 of FIG. 1) presents a userinterface, which it receives from the productivity software 100 a. Auser interacts with the user interface, and the client computing devicetransmits the user's input to the productivity software 100 a, whichresponds to the user's input via the client program.

In an embodiment, the productivity software 100 a (e.g., via the SaaSplatform software 110 a) manages various items of data stored on themedia storage device 112. These data items are presented to the clientprograms 104 a, 106 a, and 108 a as being part of one or more documents(e.g., text-based documents, spreadsheets, drawings, or presentations).However, the various data items are not necessarily organized intodocuments on the media storage device 112. Instead, the various dataitems may be separately accessible (e.g., referenced by their ownindividual globally unique IDs). In some cases, a data item may be usedand edited in one document by a user who acts as a data producer, whilea linked version of the same data item is used in another document by auser (or users) who acts as a data consumer.

In an embodiment, each user of the productivity software 100 a has anassociated user account that is managed by the productivity software 100a. For the sake of the various examples described herein, the first user104 b is assumed to be associated with a first user account, the seconduser 106 b is assumed to be associated with a second user account, andthe third user 107 b is assumed to be associated with a third useraccount. It should be noted that while the first user 104 b may utilizethe productivity software 100 a via the first user account on the firstclient device 104, the second user 106 b via the second user account onthe second client device 106, and the third user 107 b via the thirduser account on the third client device 107, various otherimplementations are also possible. For example, two or more of the users104 b, 106 b, and 107 b may utilize the productivity software 100 a viatheir respective user accounts on the same client device (e.g., one ofthe first client device 104, second client device 106, and third clientdevice 107), in an embodiment.

According to an embodiment, the productivity software 100 a managespermissions to the various data items and to documents that include suchitems. In one implementation, the permission levels granted to users fora given document include (a) owner, which gives a user permission toview the document, to edit the document, and to give others permissionsto the document, (b) editor, which gives a user permission to view thedocument and to edit the document, and (c) viewer, which only gives auser permission to view the document.

To aid in the examples described herein, it will be assumed that dataitems constituting a first document 116 and data items constituting asecond document 118 are stored on the media storage device. Among thedata items of the first document 116 are a first set of data items 120.Among the data items of the second document 118 are linked versions 122of the first set of data items 120. That is, the linked versions 122 arecopies of the data items 120, which remain consistent (e.g., have thesame values) as their original counterparts as long as there are nounpublished edits to the data items 120. Once one or more edits are madeto a data item 120, its value may no longer match that of its linkedversion 122 unless and until that data item 120 is published (i.e., theedits to the data item are published), at which point the productivitysoftware 100 a will propagate the edit (e.g., the updated value) to thelinked version 122, so that the linked version 122 once again has thesame value as the original data item 120. This update to the linkedversion 122 will therefore appear on the user interface of any user whois a consumer of data item 120 (e.g., has opened a document in which thelinked version 122 is being used), even if such user has not beengranted any permissions to the document containing the data item 120.

Turning to FIGS. 3A-3G and FIGS. 4A-4E, an example of how two userscollaborating on one document (depicted in FIGS. 3A-3G) can partiallypublish edits that are then used in another document (depicted in FIGS.4A-4E) according to an embodiment will now be described. In thisscenario, the first user 104 b and the second user 106 b arecollaborating on the first document 116 which, in this example, is atable 302 (e.g., spreadsheet) and is shown on the web-based interface ofFIG. 3A. The first user 104 b is an owner of the first document 116(e.g., has the highest level of permissions to the document) and thesecond user 106 b is an editor of the first document 116 (i.e., has alevel of permission that is lower than that of the first user 104 a).Additionally, the third user 108 b is working on the second document118, which is a presentation shown on the web-based interface of FIG.4A. The second document 118 contains copies of values of cells in thefirst document 116, which will be referred to herein as “linkedversions” of the cells (i.e., linked versions of the data itemscontained in the cells). In particular, the second document 118 containslinked versions of cells B3, B4, E2, and E3. These linked values arerespectively depicted in FIG. 4A as values 402, 404, 406, and 408. Thelinked values may be placed in segregated cells (e.g., spreadsheet cellsor table cells) or alongside regular text and/or graphics (as in FIGS.4A-4E). The fact that the content of cells B3, B4, E2, and E3 are linkedto other documents is signified in the first document 116 in FIG. 3A bya visual indicator in each of these cells (a solid triangle in the upperleft corner, in this case).

The user interface for the first document 116 (FIGS. 3A-3G) includes apublish control 304 that gives the user the option to (a) publish onlyselected edits (in this case, the edits made of one or more selectedcells) that the user has made or (b) publish all of the edits that theuser has made. Additionally, if the user has ownership permissions tothe document, a third option and a fourth option may be presented—thatof allowing the user to publish all edits in the document regardless ofwho made them and that of allowing the user to select which users topublish all changes for or to select which particular changes of otherusers to publish.

Referring to FIG. 3A, to illustrate an embodiment, cell C5 of the table302 contains a formula that sums the values contained in cells B3 and B4(e.g., =SUM(B3:B4)). Thus, any edits made to either cell B3 or B4 willimpact cell C5. Similarly, if both cell B3 and B4 are edited, then inorder to maintain data consistency, updates to all three of cells B3,B4, and C5 should be published at the same time. This is true regardlessof which user makes the changes. For example, if the first user 104 bmakes changes to both of cells B3 and B4, but chooses to publish onlythe edits to cell B3, the first computing device 100 will publish thefirst user's edits to both cells. The impact on data consistency if B4did not get published could be something obviously incorrect, like“5+4=10,” appearing in the consumer document.

An example of how a subset of edits to the table 302 are partiallypublished according to an embodiment will now be described. In thisexample, the first user 104 b (e.g., via the first client device 104)edits cells B3 and E3, while the second user 106 b (e.g., via the secondclient device 106) edits cells B4 and E2. The appearance of the firstdocument 116 on the first client device 104 as rendered by the firstclient program 104 a after the edits by the respective users haveoccurred is depicted in FIG. 3B. The appearance of the first document116 on the second client device 106 as rendered by the second clientprogram 106 a is depicted in FIG. 3C. The edits made by the first user104 b and the edits made by the second user 106 b cause visualindicators to appear on the cells that have been edited. The look ofthese visual indicators depends on which user made the edits. A user'sown edits will cause a first type of visual indicator to appear, whileanother user's edits will cause a second type of visual indicator toappear. The visual indicator indicates that there are unpublished editsto the cell. In an embodiment, the last user who changes a cell is the“owner” of the change to the cell. For example, if the first user 104 bchanges cell B3 and then the second user 106 b changes cell B4, then thesecond user 106 b is the “owner” of the resulting change to cell C5.

In this example, the first type of visual indicator is a triangle in theupper left corner of the cell with an attached stripe opposite thecorner (e.g., as shown in cell B3 of FIG. 3B). The second type of visualindicator in this example is a triangle in the upper left corner of thecell with a detached stripe opposite the corner (e.g. as shown in cellB3 of FIG. 3C). Note that the visual indicators seen by each of thefirst user and second user are not the same for the same cell. Forexample, cell B3 was edited by the first user 104 b, so on the userinterface of first user 104 b, that cell (i.e., cell B3) has the firsttype of visual indicator. On the user interface of the second user 106b, the visual indicator is of the second type, since that cell (i.e.,cell B3) was edited by “another user.”

In addition to displaying a visual indicator on the cell that is beingchanged, the client devices 104 and 106 also display a visual indicatorin any cell that is identified in a formula along with the cell beingchanged and is, itself, changed as a result. If, for example, cell C5was linked, then when the first user edits cell B3, a visual indicatorwould also appear in cell C5. This is because cell C5 contains a formulathat includes B3 and is changed as a result of the change in cell B3.Thus, any changes to cell C5 would need to be published along withchanges to cell B3 (in order to maintain data consistency). Furthermore,in this example, the second user 106 b made a change to cell B4, so thevisual indicator on cell B4 is of the second type (with a gap betweenthe triangle and the stripe in this case).

At this point, none of the edits in the first document 116 causes any ofthe values 402, 404, 406, or 408 of the second document 118 to changebecause neither the first user 104 b nor the second user 106 b haspublished any of their respective edits.

According to an embodiment, the productivity software 100 a publishesnot only edits specifically selected by a user but also those edits thatwere made to cells that are referenced by a formula that also referencesselected cell or cells. To accomplish this, in an embodiment, theproductivity software 100 a provides an operation defined by thefollowing logic. Given that the first user makes an edit to a first celland a second user makes an edit to a second cell, and given that thefirst user publishes the edit to the first cell: (a) when the first andsecond cell are referenced by a common formula, publish the edit of thesecond cell (e.g., update the linked version of the second cell on anycomputing device that is using the linked version), and (b) when thefirst cell and the second cell are not referenced by a common formula inthe table, do not publish the edit to the second cell (e.g., leave thelinked version of the second cell unchanged on any computing device thatis using the linked version).

In the example of FIG. 3B, assume that the first user 104 b activates(e.g., clicks on or touches) the publish control 304, which reacts bypresenting the first user 104 b the option to publish only the selectedchange, all of the first user's edits, or (because the first user 104 bis an owner of the first document 104) all changes in the document. Inthis example, the first user 104 b chooses to publish only the edits tocell B3. In response, the first client device 104 transmits, to thefirst computing device 100, an indication (e.g., a publication request)that cell B3 is to be published. In response, the first computing device100 determines which, if any, other cells in the table 302 depend on orare referenced by a common formula with cell B3. In this case, cell B4and cell B3 are referenced by a common formula (i.e., the formula ofcell C5). Therefore, the first computing device 100 publishes the editsto cells B3 and B4, which changes the indicators in those cells to thebasic “linked cell” indicator, as shown in FIG. 3D. The first computingdevice 100 also updates the values 402 and 404 of the second document118 as displayed on the third computing device 108 in order to reflectthe (now published) edit made to cell B4, as shown in FIG. 4B, butleaves values 406 and 408 (the linked versions of cells E2 and E3)unchanged. It should be noted that the changes to cell B4 are publishedin response to the first user's action, even though the first user 104 bdid not make any edits to that cell (it was the second user that madethe edit). It should be noted that publishing edits in fact publishesthe latest edit. For example, however many other changes were made tocell B4 (by the second user, first user, or other users), the value thatgets propagated to the linked versions of the published cells is thevalue that was in the cell at the time of publishing.

Continuing with the example, assume that the second user 106 b (e.g.,via the second client device 106) selects cell E3 and then activates(e.g., clicks on or touches) the publish control 304, which reacts bypresenting the second user 106 b the option to publish only the selectedchange or all of the second user's changes. In this example, the seconduser 106 b selects the option of publishing only the change to cell E3.In response, the second client device 106 transmits, to the firstcomputing device 100, an indication that the edit to cell E3 is to bepublished. In response, the first computing device 100 determines which,if any, other cells in the table 302 depend on or are referenced by acommon formula with cell E3. In this example, the first computing device100 determines that no other cell depends on E3 and also that no othercell is referenced by a common formula with E3. Therefore, the firstcomputing device 100 publishes the edit to cell E3, which changes theindicator in that cell to the basic “linked cell” indicator, as shown inFIG. 3E. Additionally, the first computing device 100 updates the value406 of the second document 118 as displayed on the third computingdevice 108, as shown in FIG. 4C, but leaves the value 408 (the linkedversions of cell E2) unchanged.

Changing the previous example, according to an embodiment, instead ofselecting to publish only the change to cell B3 (from the user interfaceof FIG. 3B), the first user 104 b selects the option to publish all ofthe first user's changes. In response, the first client device 104transmits, to the first computing device 100, an indication that theedits to cell B3 and cell E3 (or a blanket indication that all cellsedited by the first user 104 b) are to be published. In response, thefirst computing device 100 determines which, if any, other cells in thetable 302 depend on cell B3 or cell E3, or are referenced by a commonformula with cell B3 or E3. The first computing device 100 determinesthat cell B4 should be published. This is in addition to cells B3 andE3. Therefore, the first computing device 100 publishes the edits tocells B3, B4, and E3, which changes the indicators in those cells to thebasic “linked cell” indicator, as shown in FIG. 3F. Additionally, thefirst computing device 100 updates the values 402, 404, and 406 of thesecond document 118 as displayed on the third computing device 108, asshown in FIG. 4D, but leaves value 408 (the linked versions of cell E2)unchanged.

Changing the previous example again, according to an embodiment, insteadof selecting to publish only the change to cell B3 or to publish onlythose changes that the first user 104 b has made (from the userinterface of FIG. 3B), the first user 104 b selects the option topublish all of the changes in the first document 116 (including those ofthe second user 106 a and all other users). In response, the firstclient device 104 transmits, to the first computing device 100, anindication that all cell edits in the table 302 are to be published.Therefore, the first computing device 100 publishes the edits to cellsB3, B4, E2, and E3, which changes the indicators in those cells to thebasic “linked cell” indicator, as shown in FIG. 3G. In response, thefirst computing device 100, updates the values 402, 404, 406, and 408 ofthe second document 118 as displayed on the third computing device 108,as shown in FIG. 4E.

In an embodiment, the user interface depicted in FIGS. 3A-3G allows auser to hover over a cell in order to receive a notification regardingthe edit status of the cell. For example, in FIG. 3B, if the first userhovers over cell B3, the first computing device 100 may send the firstclient device 104 an on-screen notification that “Unpublished change byyou” while hovering over cell B4 may cause the notification “Unpublishedchanges by User 2.” Furthermore, the first computing device 100 couldsend on-screen notifications to the first user 104 b and the second user106 b when one or the other user has published edits. For example, ifthe first user 104 b publishes all of the first user's edits, the seconduser 106 b might receive the on-screen notification “User 1 just sharedchanges.”

It should be understood that the exemplary embodiments described hereinshould be considered in a descriptive sense only and not for purposes oflimitation. Descriptions of features or aspects within each embodimentshould typically be considered as available for other similar featuresor aspects in other embodiments. It will be understood by those ofordinary skill in the art that various changes in form and details maybe made therein without departing from their spirit and scope as setforth in the following claims. For example, the actions described hereincan be reordered in ways that will be apparent to those of skill in theart.

All references, including publications, patent applications, andpatents, cited herein are hereby incorporated by reference to the sameextent as if each reference were individually and specifically indicatedto be incorporated by reference and were set forth in its entiretyherein.

For the purposes of promoting an understanding of the principles of theinvention, reference has been made to the embodiments illustrated in thedrawings, and specific language has been used to describe theseembodiments. However, no limitation of the scope of the invention isintended by this specific language, and the invention should beconstrued to encompass all embodiments that would normally occur to oneof ordinary skill in the art. The terminology used herein is for thepurpose of describing the particular embodiments and is not intended tobe limiting of exemplary embodiments of the invention. In thedescription of the embodiments, certain detailed explanations of relatedart are omitted when it is deemed that they may unnecessarily obscurethe essence of the invention.

The apparatus described herein may comprise a processor, a memory forstoring program data to be executed by the processor, a permanentstorage such as a disk drive, a communications port for handlingcommunications with external devices, and user interface devices,including a display, touch panel, keys, buttons, etc. When softwaremodules are involved, these software modules may be stored as programinstructions or computer readable code executable by the processor on anon-transitory computer-readable media such as magnetic storage media(e.g., magnetic tapes, hard disks, floppy disks), optical recordingmedia (e.g., CD-ROMs, Digital Versatile Discs (DVDs), etc.), and solidstate memory (e.g., random-access memory (RAM), read-only memory (ROM),static random-access memory (SRAM), electrically erasable programmableread-only memory (EEPROM), flash memory, thumb drives, etc.). Thecomputer readable recording media may also be distributed over networkcoupled computer systems so that the computer readable code is storedand executed in a distributed fashion. This computer readable recordingmedia may be read by the computer, stored in the memory, and executed bythe processor.

Also, using the disclosure herein, programmers of ordinary skill in theart to which the invention pertains may easily implement functionalprograms, codes, and code segments for making and using the invention.

The invention may be described in terms of functional block componentsand various processing steps. Such functional blocks may be realized byany number of hardware and/or software components configured to performthe specified functions. For example, the invention may employ variousintegrated circuit components, e.g., memory elements, processingelements, logic elements, look-up tables, and the like, which may carryout a variety of functions under the control of one or moremicroprocessors or other control devices. Similarly, where the elementsof the invention are implemented using software programming or softwareelements, the invention may be implemented with any programming orscripting language such as C, C++, JAVA®, assembler, or the like, withthe various algorithms being implemented with any combination of datastructures, objects, processes, routines or other programming elements.Functional aspects may be implemented in algorithms that execute on oneor more processors. Furthermore, the invention may employ any number ofconventional techniques for electronics configuration, signal processingand/or control, data processing and the like. Finally, the steps of allmethods described herein may be performed in any suitable order unlessotherwise indicated herein or otherwise clearly contradicted by context.

For the sake of brevity, conventional electronics, control systems,software development and other functional aspects of the systems (andcomponents of the individual operating components of the systems) maynot be described in detail. Furthermore, the connecting lines, orconnectors shown in the various figures presented are intended torepresent exemplary functional relationships and/or physical or logicalcouplings between the various elements. It should be noted that manyalternative or additional functional relationships, physical connectionsor logical connections may be present in a practical device. The words“mechanism”, “element”, “unit”, “structure”, “means”, and “construction”are used broadly and are not limited to mechanical or physicalembodiments, but may include software routines in conjunction withprocessors, etc.

The use of any and all examples, or exemplary language (e.g., “such as”)provided herein, is intended merely to better illuminate the inventionand does not pose a limitation on the scope of the invention unlessotherwise claimed. Numerous modifications and adaptations will bereadily apparent to those of ordinary skill in this art withoutdeparting from the spirit and scope of the invention as defined by thefollowing claims. Therefore, the scope of the invention is defined notby the detailed description of the invention but by the followingclaims, and all differences within the scope will be construed as beingincluded in the invention.

No item or component is essential to the practice of the inventionunless the element is specifically described as “essential” or“critical”. It will also be recognized that the terms “comprises,”“comprising,” “includes,” “including,” “has,” and “having,” as usedherein, are specifically intended to be read as open-ended terms of art.The use of the terms “a” and “an” and “the” and similar referents in thecontext of describing the invention (especially in the context of thefollowing claims) are to be construed to cover both the singular and theplural, unless the context clearly indicates otherwise. In addition, itshould be understood that although the terms “first,” “second,” etc. maybe used herein to describe various elements, these elements should notbe limited by these terms, which are only used to distinguish oneelement from another. Furthermore, recitation of ranges of values hereinare merely intended to serve as a shorthand method of referringindividually to each separate value falling within the range, unlessotherwise indicated herein, and each separate value is incorporated intothe specification as if it were individually recited herein,

What is claimed is:
 1. A method for partially publishing edits to adocument, the method comprising: displaying, on a first user account ona first computing device and on a second user account, a first documentcomprising a first cell and a second cell; displaying a second documentcomprising a linked version of the first cell and a linked version ofthe second cell, wherein the content of the linked version of the firstcell matches that of the first cell and the content of the linkedversion of the second cell matches that of the second cell; receiving,from the first user account, an edit of the first cell; receiving, fromthe second user account, an edit of the second cell; receiving, from thefirst user account, an indication that the edit of the first cell is tobe published; making the edit of the first cell to the linked version ofthe first cell; and leaving the linked version of the second cellunchanged so that the content of the linked version of the second cellno longer matches that of the second cell.
 2. The method of claim 1,further comprising: receiving, from the second user account, anindication that the edit of the second cell is to be published; and inresponse to the indication received from the second user account, makingthe edit of the second cell to the linked version of the second cell. 3.The method of claim 1, wherein a first user is using the first useraccount, the method further comprising: displaying an indicator on thefirst cell to indicate that the first user has unpublished edits to thefirst cell; and removing the indicator after receiving the indicationthat the edit to the first cell is to be published.
 4. The method ofclaim 1, wherein a first user is using the first user account, themethod further comprising: displaying, on the first user account, a menuthat gives the first user the option to publish all edits that the firstuser has made to the first document.
 5. The method of claim 1, wherein afirst user is using the first user account and a second user is usingthe second user account, and wherein the first user is an owner of thefirst document, the method further comprising: displaying, on the firstuser account, a menu that gives the first user the option to publish allchanges that both the first user and the second user have made to thefirst document.
 6. A method for partially publishing edits to adocument, the method comprising: displaying on a first user account on afirst computing device and on a second user account, a first cell and asecond cell in a table of a first document; displaying a linked versionof the first cell and a linked version of the second cell in a seconddocument; receiving, from the first user account, an edit of the firstcell; receiving an edit of the second cell; receiving, from the firstuser account, an indication that the edit of the first cell is to bepublished; making the edit of the first cell to the linked version ofthe first cell; and when the first and second cells are referenced by acommon formula in the table, making the edit of the second cell to thelinked version of the second cell.
 7. The method of claim 6, whereinreceiving an edit of the second cell comprises receiving the edit of thesecond cell from the first user account.
 8. The method of claim 6,wherein receiving an edit of the second cell comprises receiving theedit of the second cell from the second user account.
 9. The method ofclaim 8, further comprising: when the first and second cells arereferenced by a common formula in the table, displaying on the seconduser account a notification that the edit of the second cell has beenpublished.
 10. The method of claim 6, further comprising: when the firstcell and the second cell are not referenced by a common formula in thetable, leaving the linked version of the second cell unchanged,receiving an indication that the edit to the second cell is to bepublished; and in response to the indication being received, making theedit of the second cell to the linked version of the second cell. 11.The method of claim 10, further comprising: in response to receiving theindication that the edit to the second cell is to be published,displaying on one or both of the first user account and the second useraccount a notification that the edit to the second cell has beenpublished.
 12. The method of claim 6, wherein a first user is using thefirst user account, the method further comprising: displaying anindicator on the first cell to indicate that the first user has anunpublished edit to the first cell; and removing the indicator afterreceiving the indication that the edit to the first cell is to bepublished.
 13. The method of claim 6, further comprising: in response toreceiving the edit of the second cell, displaying an indicator on thesecond cell to indicate that there is an unpublished edit to the secondcell; and removing the indicator on the second cell when the edit to thesecond cell is published due to the first and second cells beingreferenced by the common formula.
 14. The method of claim 6, wherein afirst user is using the first user account, the method furthercomprising: displaying, on the first user account, a menu that gives thefirst user the option to publish all edits that the first user has madein the first document.
 15. The method of claim 6, wherein a first useris using the first user account and a second user is using the seconduser account, and wherein the first user is an owner of the firstdocument, the method further comprising: displaying, on the first useraccount, a menu that gives the first user the option to publish alledits that both the first user and the second user have made to thetable.
 16. The method of claim 6, wherein a first user is using thefirst user account and a second user is using the second user account,and wherein the first user is an owner of the first document, the methodfurther comprising: displaying, on the first user account, a menu thatgives the first user the option to publish a subset of edits that eitherthe first user or the second user have made to the first document.
 17. Amethod for partially publishing edits to a document, the methodcomprising: displaying on a first user account on a first computingdevice and on a second user account, a first document comprising a firstcell and a second cell, wherein the first user account is being used bya first user and the second user account is being used by a second user;displaying a second document comprising a linked version of the firstcell and a linked version of the second cell, wherein the content of thelinked version of the first cell matches that of the first cell and thecontent of the linked version of the second cell matches that of thesecond cell; receiving, from the first user account, an edit to thefirst cell; receiving, from the second user account, an edit to thesecond cell; presenting, on the first user account, an on-screen controlthat includes a first option to publish only changes made by the firstuser and a second option to publish changes made by both the first userand the second user; providing an operation defined by: when the firstuser selects the first option, making the edit of the first cell to thelinked version of the first cell, and leaving the linked version of thesecond cell unchanged so that the content of the linked version of thesecond cell no longer matches that of the second cell; when the firstuser selects the second option, making the edit of the first cell to thelinked version of the first cell, and making the edit of the second cellto the linked version of the second cell.
 18. The method of claim 17,wherein the on-screen control further includes a third option to publishonly a single change of the first user.
 19. The method of claim 17,further comprising: displaying an indicator on the first cell toindicate that the first user has unpublished edits to the first cell;and removing the indicator after receiving the indication that the editto the first cell is to be published.
 20. The method of claim 17,further comprising: displaying an indicator on the second cell toindicate that the second user has unpublished edits to the second cell;and removing the indicator after receiving the indication that the editto the second cell is to be published.